package com.cpg.school.mybatis.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

@Mapper
public interface PrincipalMapper {
    int department_have(String name);

    int department_add(String name);

    int department_count(String name);

    List<Map> department_list(String name, int page);

    List<Map> department_select();

    String department_detail(int id);

    int department_update(int id, String name);

    int department_del(int id);

    int grade_count();

    int grade_add(int depar, String year, String name);

    List<Map> grade_list(@Param("page") int page);

    int grade_del(int id);

    Map grade_edit(int id);

    int grade_update(int id, String year, String name);

    int teacher_type_count();

    List<Map> teacher_type_list(@Param("page") int page);

    int teacher_type_add(String type_name, String type_explain);

    Map teacher_type_edit(int id);

    int teacher_type_edit_update(int id, String type_name, String type_explain);

    int teacher_type_del(@Param("id") int id);

    int teacher_count();

    int login_name_ishave(String login_name);

    int add_user_teacher(String teacher_name, String login_name, String login_pass);

    List<Map> teacher_table_list(@Param("page") int page);

    Map teacher_edit(int id);

    int teacher_update(int id, String teacher_name, String login_name, String login_pass);

    int teacher_del(int id);

    List<Map> teacher_list();

    List<Map> grade_teacher_list(int id, int page);

    int grade_teacher_del(int id);

    int grade_teacher_add(int id, String teacher_type_id, String teacher_id);
}
